package com.studio.framework.controller.monitorSystem.dao;

import com.studio.framework.controller.monitorSystem.dto.FindMonitorResDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author jujh
 * @Date 2018/7/23
 * 服务分组
 */
@Mapper
public interface ServerGroupDao {


    //查询需要监控的服务器
    @Select(" select sgroup.id groupId,sgroup.name  groupName,serverl.name serverName,serverl.ip,serverl.port,sgroup.phone from server_group sgroup LEFT JOIN server_list serverl on sgroup.id=serverl.group_id where is_start='1' ")
    List<FindMonitorResDto> findMonitorData();


}
